UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6LM6hDfTYnPOZGxNcGROqAMST2ldsrF9ulda3KRFF0='
WHERE
key_id = '2edfb3378b25aa0ae22ce749a67c8a24be7ccf9f74b09f9f5b7c3b153732b088'
AND (
token = 'G6LM6hDfTYnPOZGxNcGROqAMST2ldsrF9ulda3KRFF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)