UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H/7+eSW0NOGLjZ9TRoQd09mRPcNjd4Aclr401m67LGM='
WHERE
key_id = 'ca37affae698e78c3bf2c5c784c61566ccea73ee34a8f82b9f4de0acff48eb6f'
AND (
token = 'H/7+eSW0NOGLjZ9TRoQd09mRPcNjd4Aclr401m67LGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)