UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hNPANtBURFhNiWDWAvilCQF9SHwJnKRtrvqDggZUdw='
WHERE
key_id = 'f8373602798c1ec9fc471c609f0de81bae774f5b1f7fff7b5b1c781e4b7b23d2'
AND (
token = '6hNPANtBURFhNiWDWAvilCQF9SHwJnKRtrvqDggZUdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)