UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFmOw9AC8EIFyu69YpJrw8eUmUo9oK6V6kJ+n71eMyA='
WHERE
key_id = '8a860c9aabdf61d96a0fcf9e448aea7c7898175082a735216cc4a0b685184945'
AND (
token = 'ZFmOw9AC8EIFyu69YpJrw8eUmUo9oK6V6kJ+n71eMyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)