UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7VrCjGNBcocJm9Vkbg9d+Ief6hCSdkW5WD72vAq+Q5U='
WHERE
key_id = 'c6ebc79d2912571f8cf77e0542058636428101cc0b674dfa25af1b9325a1b8ce'
AND (
token = '7VrCjGNBcocJm9Vkbg9d+Ief6hCSdkW5WD72vAq+Q5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)