UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ho6zxNu3LVzb+KNJx4POKuocdIDo8Hpy9+/xT52P7GA='
WHERE
key_id = 'ed4a7dbf1a46f7e92d5a4c9b5ec5a52bc07bc53b5df60127b41dc70b2ab1bcdb'
AND (
token = 'Ho6zxNu3LVzb+KNJx4POKuocdIDo8Hpy9+/xT52P7GA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)