UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zuerXGNuw9rfB4d7E6vdva3zI+p9AaDtwyueMIjJ2u8='
WHERE
key_id = '9d0adf05d9c32fca1706746e80d1bb94349f7be7e5f0f78462247cb9109ea4c1'
AND (
token = 'zuerXGNuw9rfB4d7E6vdva3zI+p9AaDtwyueMIjJ2u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)