UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DxV592ZQwZM9NHFS8T2n2g2FYyen/T/s3TJ8ybxsCg='
WHERE
key_id = '2d306caf92edcef6aff6428f9e5d29a68181d22743710d704637b14b96a901ef'
AND (
token = '7DxV592ZQwZM9NHFS8T2n2g2FYyen/T/s3TJ8ybxsCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)