UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ecpinp8VDp7joJgdjBWmiG5LYyJCLO2PGv9Rq+rfWT4='
WHERE
key_id = '57f7eb6c8df58e419105dd11d975091fcc841af1278ce72d230792631f4810f3'
AND (
token = 'ecpinp8VDp7joJgdjBWmiG5LYyJCLO2PGv9Rq+rfWT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)