UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCXBsx3J7JpubF2VFCEugzC4ZG2zOk5rIup3rnu75qI='
WHERE
key_id = '01a485a8f44240f76d636beabeaf737b3774aa331622a5663773ea094a6021c3'
AND (
token = 'BCXBsx3J7JpubF2VFCEugzC4ZG2zOk5rIup3rnu75qI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)