UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aLM9xhoJafV41vnr2uKT8IF24zdreElBdUqN/83erSg='
WHERE
key_id = '6a1463856fbfa2ee234c9f1f5dc9e33c9fe19b650b7607780eb50fa907548cef'
AND (
token = 'aLM9xhoJafV41vnr2uKT8IF24zdreElBdUqN/83erSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)