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