UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mI5bzJQE5S5Mbf1zXN48UvBxUSdlIMhvqiv8W/LogQs='
WHERE
key_id = '6bb49a963733a6dff2910be19ec911a1c2736e094b0c7d6e1b133fd585a17248'
AND (
token = 'mI5bzJQE5S5Mbf1zXN48UvBxUSdlIMhvqiv8W/LogQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)