UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgAhIXetb96sEChNjZJopdpND3MuMnjZgZXia9LycnY='
WHERE
key_id = '066e2ed9c6c0b14cb5857e7d062a7fb5d6443ba694eb4f92540d1cac4eb568b9'
AND (
token = 'sgAhIXetb96sEChNjZJopdpND3MuMnjZgZXia9LycnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)