UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8/mw+y7xNCvhsWJuIwVnvey4hOnA2/6UqLjfRypLP9I='
WHERE
key_id = 'b8852c61b7e8937918ff34a4e6e45bc6b72fb0f0b604bd1c64413a88ab9d4ac2'
AND (
token = '8/mw+y7xNCvhsWJuIwVnvey4hOnA2/6UqLjfRypLP9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)