UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hoB6gtJWN1mrsC3MpM0dSnBGS44zlvy9Rse41AjEOGA='
WHERE
key_id = '652e2a1372f46a9fab67815d47b5d521b1977579f8c6645ddb8c7830b77fdad9'
AND (
token = 'hoB6gtJWN1mrsC3MpM0dSnBGS44zlvy9Rse41AjEOGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)