UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qp9QdAoidFUCr0pONckx/JJkBXmxce+NSxm5Sjh0N9E='
WHERE
key_id = 'f21501574abdcd5bea854f6c419e6a79a7b90e8ebd7b9ed29a002cada11f252b'
AND (
token = 'Qp9QdAoidFUCr0pONckx/JJkBXmxce+NSxm5Sjh0N9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)