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