UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3xQKkZugX9hIapM3Vd86vYrF07dcifMLRE0t8s96CK8='
WHERE
key_id = '126e132499301a294e33d32377bde76acb18b2df9bdf52491e57ec2ea641b738'
AND (
token = '3xQKkZugX9hIapM3Vd86vYrF07dcifMLRE0t8s96CK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)