UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e1P7v34g8dZcd3bl10MuBXLYeXHPyLC2EN8yE98Iuq0='
WHERE
key_id = 'e99edd74112f81dbecf96b58c37b86b0941b3b5aedb9eb5c54d443f8a27f2fff'
AND (
token = 'e1P7v34g8dZcd3bl10MuBXLYeXHPyLC2EN8yE98Iuq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)