UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xEgi+kKKXrCVJDdmX+kTIiowdhwP6vE4JFTETTDoXMs='
WHERE
key_id = 'f7d5c68a67eeb5ba4e621b0e4ea754d4f838658f63fdc24327ca9740d3bf01b6'
AND (
token = 'xEgi+kKKXrCVJDdmX+kTIiowdhwP6vE4JFTETTDoXMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)