UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1NSjaFapdl4OOUcA4UOT7BKVY2yA2R8mStgw5JzrfE='
WHERE
key_id = 'eb74db4c2bef1e68007ac9947e260d123780434a814aec5a5154336e71549426'
AND (
token = 'r1NSjaFapdl4OOUcA4UOT7BKVY2yA2R8mStgw5JzrfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)