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