UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hVCr+qphYSEam6l0mIcef+9GaJUAWFdFeM0JvXOaYMg='
WHERE
key_id = 'bb21196145dd3848f26684162cb33e896245b5a0e15f9dbf388b1c598dfd3735'
AND (
token = 'hVCr+qphYSEam6l0mIcef+9GaJUAWFdFeM0JvXOaYMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)