UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zlIUdr88TVEb0Xl2wXO8nXU70cVeP7jVQYuxCg8MN0='
WHERE
key_id = '1a722e4c8e4f4480e2062921d5b56a3de2e69b83cdf82a752b8412eab3e05473'
AND (
token = '0zlIUdr88TVEb0Xl2wXO8nXU70cVeP7jVQYuxCg8MN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)