UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aiEVVmZrommRPyzt0wbc8BCtwLn/gI3Pblgw1geK7M='
WHERE
key_id = '8b1e9d747c3d9cf34c4403e8b18df75ebac795696fde7a01997f5e274c6f5f5f'
AND (
token = '7aiEVVmZrommRPyzt0wbc8BCtwLn/gI3Pblgw1geK7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)