UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G3AjFYv1Lc/07TukInGbXmp7WpCjkEKbxXQW5F+Sg8o='
WHERE
key_id = 'e5e175941560527c906b235ca0c1c7851d1b0db0e665cdeb49ab204bd37bf5ba'
AND (
token = 'G3AjFYv1Lc/07TukInGbXmp7WpCjkEKbxXQW5F+Sg8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)