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