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