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